package org.dromara.community.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.dromara.community.entity.AsAppointmentFilling;

import java.util.List;
import java.util.Map;

@Mapper
public interface AsAppointmentFillingMapper extends BaseMapper<AsAppointmentFilling> {


    @Select("SELECT \n" +
        " spa.activity_name,              \n" +
        "  spa.space_address,             \n" +
        "  spa.spatial_image,\n" +
        "  ap.activity_name,\n" +
        "\tap.time_on,\n" +
        "\tap.end_time,\n" +
        "\tap.telephone,\t\n" +
        "\tap.notes\t\t\t\t \n" +
        "FROM\n" +
        "  as_appointment_filling ap\n" +
        "LEFT JOIN \n" +
        "  as_space_reservation spa \n" +
        "ON \n" +
        "  ap.activity_id = spa.id;\n")
    List<Map<String, Object>> selectAsSponsorAll();

}
